Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- tarjeta(
- nrotarjeta:char(12),
- nrocliente:int,
- validadesde:char(6), --e.g. 201106
- validahasta:char(6),
- codseguridad:char(4),
- limitecompra:decimal(8,2),
- estado:char(10) --`vigente', `suspendida', `anulada'
- )
- //AGREGA 20 clientes
- INSERT INTO tarjeta VALUES ('111122223300',01,'2015-03-04','2017-03-04','0101', 15000,00 ,'anulada');
- INSERT INTO tarjeta VALUES ('122122223301',02,'2017-01-04','2022-01-04','0102', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223303',03,'2017-02-04','2022-02-04','0103', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223304',04,'2017-10-04','2022-02-04','0104', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223305',05,'2017-10-04','2022-02-04','0105', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223306',06,'2017-10-04','2022-02-04','0106', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223307',07,'2017-10-04','2022-02-04','0107', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223308',08,'2017-10-04','2022-02-04','0108', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223309',09,'2017-10-04','2022-02-04','0109', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223310',10,'2017-10-04','2022-02-04','0100', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223311',11,'2017-10-04','2022-02-04','0111', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223312',12,'2017-10-04','2022-02-04','0112', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223313',13,'2017-10-04','2022-02-04','0113', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223314',14,'2017-10-04','2022-02-04','0114', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223315',15,'2017-10-04','2022-02-04','0115', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223316',16,'2017-10-04','2022-02-04','0116', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223317',17,'2017-10-04','2022-02-04','0117', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223318',18,'2017-10-04','2022-02-04','0118', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223319',19,'2017-10-04','2022-02-04','0119', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223320',20,'2017-10-04','2022-02-04','0120', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223323',20,'2017-10-04','2022-02-04','0123', 15000,00 ,'vigente');
- INSERT INTO tarjeta VALUES ('122122223324',19,'2017-10-04','2022-02-04','0124', 15000,00 ,'vigente');
Add Comment
Please, Sign In to add comment